﻿CREATE TABLE [dbo].[BlockFloor] (
    [Id]               INT          IDENTITY (1, 1) NOT NULL,
    [ProjectBlockId]   INT          NOT NULL,
    [FloorNo]          NVARCHAR (5) NOT NULL,
    [DoorPlateFloorNo] NVARCHAR (5) NULL,
    CONSTRAINT [PK_ProjectFloor] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_BlockFloor_ProjectBlock] FOREIGN KEY ([ProjectBlockId]) REFERENCES [dbo].[ProjectBlock] ([Id])
);

